package com.huizu.common.oracleDb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * @Author: pjl
 * @Date: 2024/10/24
 * @ClassName: OracleDbConnection
 * @Description: oracle数据连接
 */
public class OracleDbConnection {

    private static final String URL = "jdbc:oracle:thin:@//172.16.4.17:1521/orcl";
    private static final String USER = "sjgx_ldjypt";
    private static final String PASSWORD = "LDmw1jy3";


//    private static final String URL = "jdbc:oracle:thin:@//127.0.0.1:1521/orcl";
//    private static final String USER = "sys as sysdba";
//    private static final String PASSWORD = "13Qs##123344";

//    private static final String URL = "jdbc:mysql://47.104.196.119:3307/laodongjiaoyu?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8";
//    private static final String USER = "root";
//    private static final String PASSWORD = "LDjy110,/_`";


    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(URL, USER, PASSWORD);
    }
}
